Due to stronger security on network communications enabled by recent service packs on Microsoft server operating systems (and present by default in newer server operating systems), network Distributed Transaction Coordinator (MSDTC) access might be disabled on one or both of the SQL server hosts in a multi-server configuration of iMIS Analytics.
If you have installed Analytics in a multi-server configuration, you must ensure that both the iMIS host and the Analytics host are configured to allow network DTC access.
Before you begin
Ensure that both your Analytics host and your iMIS host meet all system requirements (see Analytics system requirements).
To enable network DTC access for multi-server configurations
1. On the Analytics host, choose Start > Control Panel > Administrative Tools > Component Services.
The Component Services window appears.
2. In the console tree, click Component Services, then expand the Computers sub-folder.
The My Computer icon appears in the console tree.
3. Right-click the My Computer icon and choose Properties.
4. On the MSDTC tab, click Security Configuration.
The Security Configuration window appears.
5. In the Security Settings area, ensure that all of the following checkboxes are selected:
□ Network DTC Access
□ Allow Remote Clients
□ Allow Remote Administration
□ Allow Inbound
□ Allow Outbound
□ Enable XA Transactions
6. In the Transaction Manager Communication section, ensure that the Mutual Authentication Required option is selected.
7. Click OK.
A confirmation message to stop and restart the MSDTC service appears.
8. Click Yes, then click OK at all further messages and windows.
9. Repeat this process on the iMIS host.